Line and Stacked column Visual 16
Visual 2: Line and Stacked Column Visual =: Deaths Per Mth /%YoY,
%MoM by Event Type
Fields Tab
Step 1
· Shared Axis: Event_Type
·
Column Values: Deaths Per Mth
·
Line Values: %YoY,
%MoM
Format
Tab
·
General: X Position = 231, Y Position = 410,
Width = 515, Height = 294
·
Maintain layer order = off
Step 2
Legend:
On, Position = Top, Title
= off, Color = #00000,
font family = DIN,
Text size = 10, Style = Markers Only, circle defaut icon = on
X
Axis: Color = #000000,
Text Size = 9, Font family = Segoe UI, Minimum category width = 20, Maximum
Size = 25%, Inner Padding = 20%, Concatenate labels = On, Title = Off
Y
Axis: Position = Left, Scale Type = Linear, start = Auto, End = Auto, Color = #000000, Text size = 10, Font
family = Segoe UI, Display Units = Auto, Value Decimal places = Auto, Title = Off, Grid line = on, Line color = #CCCCCC, Stork width = 2, Line
style = Doted, Show
secondary = on, Aline
zeros = off
Step 3
Zoom Slider = off
Data
Colors, YoY% = #E1A204,
MoM = #33DBFF, Show all = on, (Color = #000000)
Data Label = On, Color
= #FFFFFF, Display
Units = Auto, Value Decimal places = 2, Orientation = Horizontal, Position =
Auto, Text Size = 9, Font Family = DIN, Show Background = off, Customize series = off
Shapes: Shade area = On,
Stroke width = 3, Join Type = Round, Line Style = Solid, show marker = 0n, Marker
size = 5, Marker color = #FFFFFF, stepped
= off, customize series = on,
%YoY, Shad area = on, Stork width = 3, Join type = round, Show maker = on, Marker Size = 5, Marker color = E1A204, Stepped =
off
Plot
Area:
Transparency = 0%
Step
4
Title = On, Title Text = By Event Type, Title Heading = Heading
3; Word wrap = On, font
color = #FFFFFF, Background
color = #000000, Alignment
= Center, Text Size
= 15, Font Family =
Segoe UI
Background: On, color = #FFFFF, Transparency
= 0%
Lock
Aspect
= off
Border: Color = #E6E6E6, Radius =
0 px
Shadow: Off
Tooltip = On, Type = Report
Page, Page = Auto, Label Text color = #C8C8C8, Value text color = #EAEAEA, Text
size = 9, Font family = Segoe UI, Background color = #333333, Transparency = 5%
Visual
header
= On, background color = #FFFFFF, Boarder = #FFFFFF, Transparency = 0%, Icon
color = #333333, Visual information icon = On, Visual warning icon = On, Visual
error icon = on, Drill on drop down = On, Drill up icon = On, Drill down icon =
On, Show next level icon = On, Expand to next level icon = On, Expand to next
level icon = on, Pin icon = On, Focus mode icon = On, Filter icon = On, See
data layout icon = On, More Options icon = On, Visual Header tooltip icon = off
Step 5
Select “Filter” From “View” menu then in Filter click “event type” then select the following type:
Use the following step by step Gif to create the second visual
for Step 1
for Step 2
for Step 3
for Step 4
for Step 5
Line and Stacked Column Chart in Power BI
https://www.tutorialgateway.org/line-and-stacked-column-chart-in-power-bi/